package com.ipet.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ipet.system.pojo.SysRole;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface SysRoleMapper extends BaseMapper<com.ipet.system.pojo.SysRole> {
    @Select("SELECT r.id , r.role_name , r.privilege FROM tb_sys_role r , tb_sys_user_role ur where r.id = ur.r_id and ur.s_id = #{uId} ")
    List<SysRole> findByUId(Integer uId);
}
